Foreign Key Data Selection is a useful tool for letting you to get the available value from the reference table in an easy way. It allows you to show additional record(s) from the reference table and search for a particular record(s).
To include data to the record, just simply click
open the editor for editing.
- Just simply double-click to select the desired data.
Hint: - By default, the number of records showed per page is 100. To show all records, control-click anywhere on the grid and select Show All. To adjust the global settings, see Preferences.
- To refresh the record, control-click anywhere on the grid and select Refresh.
- Click
to open a panel on the left for showing a list of column name(s). Just simply click to show the additional column. To remove the column(s), uncheck them in the same way.
Hint: To find for the text in the editor window, control-click anywhere on the grid and select Find or press Cmd-F. - Enter a value into the edit box and click
to filter for the particular record(s).
Hint: To remove the filter results, control-click anywhere on the grid and select Show All.